from applications.extensions import db

class ViolationInfo(db.Model):
    __tablename__ = 'violation_info'
    id = db.Column(db.Integer, primary_key=True)
    user_phonenum = db.Column(db.String(128), db.ForeignKey('user.user_phonenum'),nullable=False)
    violation_time = db.Column(db.DateTime, nullable=False)
    isbn = db.Column(db.String(128), db.ForeignKey('book_info.isbn'),nullable=False)
    violation_fee = db.Column(db.String(20), nullable=False)
